# 受试者信息的存储
import pandas as pd

speed0=[4, 5.2, 6.4, 7.6, 8.8, 10, 11.2, 12.4, 13.6, 14.8, 16, 17.2]
speed1=[5, 6.2, 7.4, 8.6, 9.8, 11, 12.2, 13.4, 14.6, 15.8, 17, 18.2]

# 受试者参与统计
subject = [
    ['1001-1-1', '2024.6.4', '1', '23', '178', '70', '26.4', '45.8', 'l', '0.98', '1.27', '2.37', '6.25', '6.21',
     '8.15', '12.36', '15.33', '', '', '','', ''],
    ['1001-1-2', '2024.6.20', '1', '23', '178', '70', '28', '48.2', 'l', '1.38 ', '3.29', '2.52', '4.74', '7.13',
     '8.96', '13.53', '14.94', '', '', '','', ''],
    ['1002-1-1', '', '1', '26', '188', '78', '', '', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
    ['1002-1-2', '2024.6.26', '1', '26', '188', '78', '26.9', '41.9', 'r', '2.73', '1.72', '1.81', '2.33', '2.79',
     '4.15', '6.15', '10.83', '', '', '','', ''],
    ['1003-1-1', '2024.6.12', '1', '28', '183', '73', '26.4', '56.2', 'l', '1.46', '0.87', '1.28', '1.46', '2.37',
     '3.09', '4.36', '', '', '', '','', ''],
    ['1004-1-1', '2024.6.17', '0', '19', '165', '47.5', '26.5', '43.80%', 'l', '3.62', '1.12', '0.95', '1.83', '2.25',
     '3.43', '5.13', '9.72', '', '', '', '', ''],
    ['1005-1-1', '2024.6.21', '1', '21', '185', '80', '26.5', '40.5', 'l', '1.69', '1.08', '0.98', '1.18', '1.62',
     '1.74', '2.06', '3.14', '5.23', '', '','', ''],
    ['1006-1-1', '2024.6.21', '1', '20', '183', '74', '26.1', '42.8', 'l', '1.71', '2.27', '2.82', '3.22', '4.16',
     '6.41', '', '', '', '', '','', ''],
    ['1007-1-1', '2024.6.21', '1', '23', '190', '84', '26.8', '52', 'l', '1.52', '3.54', '3.27', '4.26', '6.41', '10.1',
     '14.57', '', '', '', '','', ''],
    ['1008-1-1', '2024.6.21', '1', '20', '181', '65', '26.4', '46.7', 'l', '1.71', '2.12', '1.89', '1.65', '1.64',
     '2.63', '2.86', '3.99', '', '', '', '', ''],
    ['1009-1-1', '2024.6.24', '0', '22', '160', '48', '26.8', '39.4', 'l', '1.01', '3.29', '1.91', '2.96', '4.17',
     '6.29', '10.9', '', '', '', '', '', ''],
    ['1010-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
     '4.56', '7.79', '10.48', '', '', '','', ''],
    ['1011-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
     '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1012-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '2.29',	'3.02'	,'2.26'	,'2.45',	'2.09',	'2.78',	'3.39',	'4.33',	'6.66',	'10.69',	'12.28', ''],
    ['1013-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1014-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1015-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1016-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1017-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1018-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1019-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1020-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1021-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1022-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1023-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1024-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1025-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1026-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1027-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1028-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1029-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1030-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1031-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1032-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1033-1-1', '2024.7.6', '1', '21', '168', '58', '26.4', '65.1', 'l', '1.43', '2.13', '2.11', '2.1', '2.48',
         '3.52', '4.91', '6.62', '', '', '', '', ''],
    ['1034-1-1', '2024.7.6', '1', '21', '168', '58', '29.1', '53', 'l', '2.05', '1.86', '1.44', '2.16', '3.02',
         '4.21', '6.73', '10.67', '', '', '', '', ''],
    ['1035-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1036-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1037-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1038-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1039-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1040-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1041-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1042-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
         '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1043-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
     '4.56', '7.79', '10.48', '', '', '', '', ''],
    ['1044-1-1', '2024.6.24', '0', '21', '168', '58', '26.5', '32.90', 'l', '3.03', '1.8', '1.7', '2.87', '3.56',
     '4.56', '7.79', '10.48', '', '', '', '', ''],




    ['1045-1-1', '2024.6.21', '1', '37', '181', '73', '26.4', '46.7', 'l', '1.94', '1.85', '1.75', '1.77', '',
     '2.03', '4.65', '7.42', '', '', '', '', ''],
    ['1046-1-1', '2024.6.21', '1', '29'	,'174',	'73', '26.4', '46.7', 'l', '1.98', '1.44', '1.66', '1.39', '1.11',
     '1.39', '2.17', '3.56', '5.99', '10.52', '','', ''],

    ['1047-1-1', '2024.6.21', '1', '21',	'180'	,'73', '26.4', '46.7', 'l', '1.52', '2.95', '2.55', '2.98', '3.65',
     '5.53', '7.53', '7.81', '', '', '', '', ''],
    ['1048-1-1', '2024.6.21', '1', '23',	'178',	'68', '26.4', '46.7', 'l', '2.21', '2.55', '2.70', '3.67', '4.18',
     '5.19', '5.79', '7.96', '10.43', '', '','', ''],
    ['1049-1-1', '2024.6.21', '0', '24'	,'168',	'57', '26.4', '46.7', 'l', '1.74', '2.35', '1.76', '2.08', '2.62',
     '4.83', '5.05', '7.67', '', '', '', '', ''],
    ['1050-1-1', '2024.6.21', '0', '24', '163', '56', '26.4', '46.7', 'l', '1.59', '2.49', '1.94', '1.88', '1.78',
     '1.94', '2.94', '3.68', '6.00', '', '','', ''],
    ['1051-1-1', '2024.6.21', '0', '24', '163', '56', '26.4', '46.7', 'l', '1.59', '2.49', '1.94', '1.88', '1.78',
     '1.94', '2.94', '3.68', '6.00', '', '','', ''],
    ['1052-1-1', '2024.6.21', '0', '24', '163', '56', '26.4', '46.7', 'l', '1.59', '2.49', '1.94', '1.88', '1.78',
     '1.94', '2.94', '3.68', '6.00', '', '','', ''],
    ['1053-1-1', '2024.6.21', '0', '24', '163', '56', '26.4', '46.7', 'l', '1.59', '2.49', '1.94', '1.88', '1.78',
     '1.94', '2.94', '3.68', '6.00', '', '','', ''],
    ['1054-1-1', '2024.6.21', '0', '24', '163', '56', '26.4', '46.7', 'l', '1.59', '2.49', '1.94', '1.88', '1.78',
     '1.94', '2.94', '3.68', '6.00', '', '','', ''],
    ['1055-1-1', '2024.6.21', '0', '24', '163', '56', '26.4', '46.7', 'l', '1.59', '2.49', '1.94', '1.88', '1.78',
     '1.94', '2.94', '3.68', '6.00', '', '', '', ''],
    ['1056-1-1', '2024.7.22', '0', '21', '160', '49', '29.1', '62.4', 'r', '1.22', '2.77', '2.61', '3.66', '5.25',
     '8.06', '', '', '', '', '','', ''],
    ['1057-1-1', '2024.7.22', '0', '22', '158', '60', '28', '57.9', 'r', '1.20', '2.65', '2.01', '2.04', '2.23',
     '2.60', '4.40', '7.60', '12.94', '', '','', ''],


]

# subject2=[['1001-2-1', '2024.6.6', '1', '23', '178', '70', '30.9', '37.8', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#     ['1001-2-2', '2024.6.14', '1', '23', '178', '70', '34.8', '39.1', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#     ['1002-2-1', '2024.6.6', '1', '26', '188', '78', '30.9', '37.8', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#     ['1002-2-2', '2024.6.14', '1', '26', '188', '78', '34.8', '39.1', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#     ['1003-2-1', '2024.6.14', '1', '28', '183', '73', '28.7', '30', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#     ['1006-2-1', '2024.6.25', '1', '20', '183', '74', '30.7', '32.6', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#     ['1007-2-1', '2024.6.23', '1', '23', '190', '84', '29.3', '31', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#     ['1008-2-1', '2024.6.25', '1', '20', '181', '65', '30.7', '32.9', 'l', '', '', '', '', '', '', '', '', '', '', '','', ''],
#
#     ['1004-2-1', '2024.6.21', '0', '19', '165', '47.5', '24.3', '76.5', 'l', '', '', '', '', '', '', '', '', '', '','','', ''],]
# subject=subject+subject2
subject = pd.DataFrame(subject)
subject.columns = ['id_test', 'date', 'sex', 'age', 'heihgt', 'weight', 'temperature', 'humidity', 'hand', 'rest',
                   'la_1', 'la_2', 'la_3', 'la_4', 'la_5', 'la_6', 'la_7', 'la_8', 'la_9', 'la_10','la_11','la_12']


# 文件类型

file_dict = ['ppg', 'ecg', 'rri', 'singlework', 'singledetail', 'img', 'fit', 'rrdata']

# 全部整合所需表头
all_columns = ['ecg_timestramp', 'voltage', 'stage', 'psychology_RPE', 'physiology_RPE', 'rr_ecg_timestamp', 'HR_ecg',
               'rr1_ecg', 'rr2_ecg', 'rr3_ecg', 'rr4_ecg', 'rr5_ecg',
               'rr_ppg_timestamp', 'sqi', 'rr_ppg',
               'ACC_TIME', 'PPG_TIME', 'GYRO_TIME', 'AMBG1', 'GREEN1', 'GREEN2', 'AMBG2', 'AMBG3', 'IR', 'RED', 'AMBG4',
               'ACC_X',
               'ACC_Y', 'ACC_Z', 'GYRO_X', 'GYRO_Y', 'GYRO_Z',
               'work_name', 'work_time', 'work_HR'
               ]

